﻿    -- DROP FUNCTION "Remove_Institution"(VARCHAR);
    CREATE OR REPLACE FUNCTION "Remove_Institution" (
        id integer
    ) 
    RETURNS void 
    AS 
    $$
    /***************************************************************************************************
    **  Function:	public."Remove_Institution"
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Remove institution from institution table.
    **
    **  Parameters (1):
    **
    **      id  VARCHAR(36)    -
    **
    **  Return:
    **
    **      void
    **
    **  Sample call:
    **
    **      SELECT * FROM public."Institution";
    **      SELECT "Remove_Institution"('7'); 
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial prototype
    ** 
    **  Status:
    **
    **      Dev
    ** 
    ***************************************************************************************************/
    BEGIN
        DELETE  
        FROM    public."Institution"
        WHERE   "Id" = id;
    END;
    $$ LANGUAGE plpgsql;

   